Data from Sustainability Solution is loaded into dynamic cubes using a combination of standard dimensions and dynamic dimensions. Review the following information to help you navigate Cube Views based on the ESG dynamic cube.
| Entity | Sustainability Solution data is loaded into dynamic cubes based on the profile's Dynamic Cube Reporting Entity. See Profiles. |
| Consolidation | Sustainability Solution data is loaded into the Local member. |
| Scenario | Sustainability Solution data is associated with a scenario on data entry. |
| Time | Sustainability Solution data is associated with the time period it was entered in, for example, 2025M1. |
| View |
Numeric data is loaded into either the Periodic member or the YTD member, depending on the input basis selected. See Definitions. Narrative data is displayed in the Annotation member as plain text and the VarianceExplanation member as rich text. |
| Account (Dynamic) | The Account dimension is dynamically created and includes all Sustainability Solution framework KPIs. Each data entry in Sustainability Solution is associated with a definition/KPI. |
| Flow |
Sustainability Solution data is loaded into the None member by default. |
| Origin | Sustainability Solution data is loaded into the Import member. |
| IC | Sustainability Solution data is loaded into the None member by default. |
| UD 1-UD 8 |
UD dimensions are used for the dynamically created control list and unit of measure dimensions. TIP: For numeric entries, use TotalControlList and Total UOMs for a simple way to locate data. For narrative entries, Control Lists should be set to the control list answer selected on data entry, and UOM should be set to none. |
